package com.itheima.mapper;

import com.itheima.pojo.Member;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface MemberMapper {
    Member findByTelephone(@Param("telephone")  String telephone);

    void add(Member member);

    int findMemberCountByMonth(@Param("monthBegin") String monthBegin,@Param("monthEnd") String monthEnd);

    List<Map> getMemberReportByDateRange(@Param("dateBegin") String dateBegin, @Param("dateEnd") String dateEnd);

    List<Map> getMemberReportByAge();

    List<Map> getSexReport();
}
